Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 3817 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 361.7 KiB |
| Average record size in memory | 97.0 B |
Variable types
| Numeric | 9 |
|---|---|
| Categorical | 3 |
| Boolean | 1 |
isLastSmallPeriod has constant value "True" | Constant |
startDate has a high cardinality: 1217 distinct values | High cardinality |
endDate has a high cardinality: 1447 distinct values | High cardinality |
minDate has a high cardinality: 1026 distinct values | High cardinality |
df_index has unique values | Unique |
s_bias has unique values | Unique |
m_bias has unique values | Unique |
l_bias has unique values | Unique |
Reproduction
| Analysis started | 2021-01-10 15:13:24.467959 |
|---|---|
| Analysis finished | 2021-01-10 15:13:32.591240 |
| Duration | 8.12 seconds |
| Software version | pandas-profiling v2.10.0 |
| Download configuration | config.yaml |
| Distinct | 3817 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10680.87006 |
|---|---|
| Minimum | 1 |
| Maximum | 21001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 29.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1088.4 |
| Q1 | 5433 |
| median | 10739 |
| Q3 | 16075 |
| 95-th percentile | 19994.4 |
| Maximum | 21001 |
| Range | 21000 |
| Interquartile range (IQR) | 10642 |
Descriptive statistics
| Standard deviation | 6089.162892 |
|---|---|
| Coefficient of variation (CV) | 0.5700998945 |
| Kurtosis | -1.203120547 |
| Mean | 10680.87006 |
| Median Absolute Deviation (MAD) | 5325 |
| Skewness | -0.03841756531 |
| Sum | 40768881 |
| Variance | 37077904.72 |
| Monotocity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2049 | 1 | < 0.1% |
| 19460 | 1 | < 0.1% |
| 17730 | 1 | < 0.1% |
| 3395 | 1 | < 0.1% |
| 18696 | 1 | < 0.1% |
| 1354 | 1 | < 0.1% |
| 3403 | 1 | < 0.1% |
| 7501 | 1 | < 0.1% |
| 1358 | 1 | < 0.1% |
| 7505 | 1 | < 0.1% |
| Other values (3807) | 3807 |
| Value | Count | Frequency (%) |
| 1 | 1 | |
| 4 | 1 | |
| 12 | 1 | |
| 15 | 1 | |
| 21 | 1 |
| Value | Count | Frequency (%) |
| 21001 | 1 | |
| 20999 | 1 | |
| 20996 | 1 | |
| 20992 | 1 | |
| 20987 | 1 |
code
Real number (ℝ≥0)
| Distinct | 300 |
|---|---|
| Distinct (%) | 7.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 380205.8108 |
|---|---|
| Minimum | 1 |
| Maximum | 603993 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 29.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 538 |
| Q1 | 2311 |
| median | 600104 |
| Q3 | 600886 |
| 95-th percentile | 601901 |
| Maximum | 603993 |
| Range | 603992 |
| Interquartile range (IQR) | 598575 |
Descriptive statistics
| Standard deviation | 280415.1958 |
|---|---|
| Coefficient of variation (CV) | 0.7375352711 |
| Kurtosis | -1.635403866 |
| Mean | 380205.8108 |
| Median Absolute Deviation (MAD) | 1529 |
| Skewness | -0.5457610591 |
| Sum | 1451245580 |
| Variance | 7.863268202 × 1010 |
| Monotocity | Increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600015 | 23 | 0.6% |
| 600048 | 23 | 0.6% |
| 601166 | 22 | 0.6% |
| 2179 | 22 | 0.6% |
| 963 | 21 | 0.6% |
| 600383 | 20 | 0.5% |
| 600000 | 20 | 0.5% |
| 2142 | 20 | 0.5% |
| 600085 | 20 | 0.5% |
| 600016 | 20 | 0.5% |
| Other values (290) | 3606 |
| Value | Count | Frequency (%) |
| 1 | 16 | |
| 2 | 15 | |
| 63 | 13 | |
| 69 | 16 | |
| 100 | 12 |
| Value | Count | Frequency (%) |
| 603993 | 11 | |
| 603986 | 5 | |
| 603899 | 7 | |
| 603833 | 6 | |
| 603799 | 9 |
lossRate
Real number (ℝ)
| Distinct | 3787 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -0.167572457 |
|---|---|
| Minimum | -0.6474201474 |
| Maximum | -0.002478314746 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 29.9 KiB |
Quantile statistics
| Minimum | -0.6474201474 |
|---|---|
| 5-th percentile | -0.3639826316 |
| Q1 | -0.2071078431 |
| median | -0.15 |
| Q3 | -0.1025316456 |
| 95-th percentile | -0.04903941719 |
| Maximum | -0.002478314746 |
| Range | 0.6449418327 |
| Interquartile range (IQR) | 0.1045761976 |
Descriptive statistics
| Standard deviation | 0.09693163845 |
|---|---|
| Coefficient of variation (CV) | -0.5784461252 |
| Kurtosis | 3.456829427 |
| Mean | -0.167572457 |
| Median Absolute Deviation (MAD) | 0.05128755365 |
| Skewness | -1.56155528 |
| Sum | -639.6240684 |
| Variance | 0.009395742533 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -0.1 | 4 | 0.1% |
| -0.1111111111 | 3 | 0.1% |
| -0.2 | 3 | 0.1% |
| -0.1264367816 | 2 | 0.1% |
| -0.2076335878 | 2 | 0.1% |
| -0.1779141104 | 2 | 0.1% |
| -0.2262038074 | 2 | 0.1% |
| -0.1363636364 | 2 | 0.1% |
| -0.08135283364 | 2 | 0.1% |
| -0.2307692308 | 2 | 0.1% |
| Other values (3777) | 3793 |
| Value | Count | Frequency (%) |
| -0.6474201474 | 1 | |
| -0.6473358116 | 1 | |
| -0.6232077206 | 1 | |
| -0.6113454407 | 1 | |
| -0.6104495747 | 1 |
| Value | Count | Frequency (%) |
| -0.002478314746 | 1 | |
| -0.002485501243 | 1 | |
| -0.004375 | 1 | |
| -0.005015045135 | 1 | |
| -0.007796994613 | 1 |
| Distinct | 1217 |
|---|---|
| Distinct (%) | 31.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 29.9 KiB |
| 2016-08-15 | 30 |
|---|---|
| 2010-11-08 | 30 |
| 2015-01-05 | 28 |
| 2019-04-08 | 28 |
| 2020-08-17 | 27 |
| Other values (1212) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 38170 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 497 ? |
|---|---|
| Unique (%) | 13.0% |
Sample
| 1st row | 2011-05-20 |
|---|---|
| 2nd row | 2011-07-29 |
| 3rd row | 2013-03-06 |
| 4th row | 2013-10-30 |
| 5th row | 2014-08-04 |
| Value | Count | Frequency (%) |
| 2016-08-15 | 30 | 0.8% |
| 2010-11-08 | 30 | 0.8% |
| 2015-01-05 | 28 | 0.7% |
| 2019-04-08 | 28 | 0.7% |
| 2020-08-17 | 27 | 0.7% |
| 2018-02-05 | 25 | 0.7% |
| 2020-03-05 | 22 | 0.6% |
| 2015-06-15 | 19 | 0.5% |
| 2019-04-19 | 19 | 0.5% |
| 2019-04-09 | 18 | 0.5% |
| Other values (1207) | 3571 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2016-08-15 | 30 | 0.8% |
| 2010-11-08 | 30 | 0.8% |
| 2015-01-05 | 28 | 0.7% |
| 2019-04-08 | 28 | 0.7% |
| 2020-08-17 | 27 | 0.7% |
| 2018-02-05 | 25 | 0.7% |
| 2020-03-05 | 22 | 0.6% |
| 2015-06-15 | 19 | 0.5% |
| 2019-04-19 | 19 | 0.5% |
| 2019-04-09 | 18 | 0.5% |
| Other values (1207) | 3571 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 9178 | |
| - | 7634 | |
| 1 | 6892 | |
| 2 | 6630 | |
| 3 | 1277 | 3.3% |
| 5 | 1181 | 3.1% |
| 9 | 1181 | 3.1% |
| 8 | 1117 | 2.9% |
| 7 | 1079 | 2.8% |
| 4 | 1008 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 30536 | |
| Dash Punctuation | 7634 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 9178 | |
| 1 | 6892 | |
| 2 | 6630 | |
| 3 | 1277 | 4.2% |
| 5 | 1181 | 3.9% |
| 9 | 1181 | 3.9% |
| 8 | 1117 | 3.7% |
| 7 | 1079 | 3.5% |
| 4 | 1008 | 3.3% |
| 6 | 993 | 3.3% |
| Value | Count | Frequency (%) |
| - | 7634 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 38170 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 9178 | |
| - | 7634 | |
| 1 | 6892 | |
| 2 | 6630 | |
| 3 | 1277 | 3.3% |
| 5 | 1181 | 3.1% |
| 9 | 1181 | 3.1% |
| 8 | 1117 | 2.9% |
| 7 | 1079 | 2.8% |
| 4 | 1008 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 38170 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 9178 | |
| - | 7634 | |
| 1 | 6892 | |
| 2 | 6630 | |
| 3 | 1277 | 3.3% |
| 5 | 1181 | 3.1% |
| 9 | 1181 | 3.1% |
| 8 | 1117 | 2.9% |
| 7 | 1079 | 2.8% |
| 4 | 1008 | 2.6% |
| Distinct | 1447 |
|---|---|
| Distinct (%) | 37.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 29.9 KiB |
| 2020-10-09 | 96 |
|---|---|
| 2019-05-10 | 24 |
| 2019-05-13 | 23 |
| 2019-05-14 | 22 |
| 2019-05-15 | 19 |
| Other values (1442) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 38170 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 590 ? |
|---|---|
| Unique (%) | 15.5% |
Sample
| 1st row | 2011-06-16 |
|---|---|
| 2nd row | 2011-08-10 |
| 3rd row | 2013-04-16 |
| 4th row | 2013-12-24 |
| 5th row | 2014-10-09 |
| Value | Count | Frequency (%) |
| 2020-10-09 | 96 | 2.5% |
| 2019-05-10 | 24 | 0.6% |
| 2019-05-13 | 23 | 0.6% |
| 2019-05-14 | 22 | 0.6% |
| 2019-05-15 | 19 | 0.5% |
| 2015-07-06 | 18 | 0.5% |
| 2015-07-08 | 17 | 0.4% |
| 2015-07-03 | 16 | 0.4% |
| 2019-05-09 | 16 | 0.4% |
| 2019-05-08 | 16 | 0.4% |
| Other values (1437) | 3550 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2020-10-09 | 96 | 2.5% |
| 2019-05-10 | 24 | 0.6% |
| 2019-05-13 | 23 | 0.6% |
| 2019-05-14 | 22 | 0.6% |
| 2019-05-15 | 19 | 0.5% |
| 2015-07-06 | 18 | 0.5% |
| 2015-07-08 | 17 | 0.4% |
| 2015-07-03 | 16 | 0.4% |
| 2019-05-09 | 16 | 0.4% |
| 2019-05-08 | 16 | 0.4% |
| Other values (1437) | 3550 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 9115 | |
| - | 7634 | |
| 1 | 6898 | |
| 2 | 6739 | |
| 9 | 1376 | 3.6% |
| 3 | 1375 | 3.6% |
| 5 | 1142 | 3.0% |
| 7 | 1122 | 2.9% |
| 6 | 1004 | 2.6% |
| 8 | 921 | 2.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 30536 | |
| Dash Punctuation | 7634 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 9115 | |
| 1 | 6898 | |
| 2 | 6739 | |
| 9 | 1376 | 4.5% |
| 3 | 1375 | 4.5% |
| 5 | 1142 | 3.7% |
| 7 | 1122 | 3.7% |
| 6 | 1004 | 3.3% |
| 8 | 921 | 3.0% |
| 4 | 844 | 2.8% |
| Value | Count | Frequency (%) |
| - | 7634 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 38170 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 9115 | |
| - | 7634 | |
| 1 | 6898 | |
| 2 | 6739 | |
| 9 | 1376 | 3.6% |
| 3 | 1375 | 3.6% |
| 5 | 1142 | 3.0% |
| 7 | 1122 | 2.9% |
| 6 | 1004 | 2.6% |
| 8 | 921 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 38170 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 9115 | |
| - | 7634 | |
| 1 | 6898 | |
| 2 | 6739 | |
| 9 | 1376 | 3.6% |
| 3 | 1375 | 3.6% |
| 5 | 1142 | 3.0% |
| 7 | 1122 | 2.9% |
| 6 | 1004 | 2.6% |
| 8 | 921 | 2.4% |
| Distinct | 1026 |
|---|---|
| Distinct (%) | 26.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 29.9 KiB |
| 2019-05-09 | 84 |
|---|---|
| 2019-05-06 | 69 |
| 2015-07-08 | 64 |
| 2020-02-03 | 60 |
| 2018-02-09 | 41 |
| Other values (1021) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 38170 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 424 ? |
|---|---|
| Unique (%) | 11.1% |
Sample
| 1st row | 2011-06-16 |
|---|---|
| 2nd row | 2011-08-08 |
| 3rd row | 2013-04-15 |
| 4th row | 2013-12-24 |
| 5th row | 2014-09-22 |
| Value | Count | Frequency (%) |
| 2019-05-09 | 84 | 2.2% |
| 2019-05-06 | 69 | 1.8% |
| 2015-07-08 | 64 | 1.7% |
| 2020-02-03 | 60 | 1.6% |
| 2018-02-09 | 41 | 1.1% |
| 2015-02-06 | 35 | 0.9% |
| 2020-09-10 | 35 | 0.9% |
| 2015-07-07 | 34 | 0.9% |
| 2020-03-23 | 33 | 0.9% |
| 2016-01-11 | 28 | 0.7% |
| Other values (1016) | 3334 |
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2019-05-09 | 84 | 2.2% |
| 2019-05-06 | 69 | 1.8% |
| 2015-07-08 | 64 | 1.7% |
| 2020-02-03 | 60 | 1.6% |
| 2018-02-09 | 41 | 1.1% |
| 2015-02-06 | 35 | 0.9% |
| 2020-09-10 | 35 | 0.9% |
| 2015-07-07 | 34 | 0.9% |
| 2020-03-23 | 33 | 0.9% |
| 2016-01-11 | 28 | 0.7% |
| Other values (1016) | 3334 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 9163 | |
| - | 7634 | |
| 2 | 6772 | |
| 1 | 6478 | |
| 9 | 1457 | 3.8% |
| 3 | 1446 | 3.8% |
| 6 | 1133 | 3.0% |
| 7 | 1102 | 2.9% |
| 5 | 1100 | 2.9% |
| 8 | 1051 | 2.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 30536 | |
| Dash Punctuation | 7634 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 9163 | |
| 2 | 6772 | |
| 1 | 6478 | |
| 9 | 1457 | 4.8% |
| 3 | 1446 | 4.7% |
| 6 | 1133 | 3.7% |
| 7 | 1102 | 3.6% |
| 5 | 1100 | 3.6% |
| 8 | 1051 | 3.4% |
| 4 | 834 | 2.7% |
| Value | Count | Frequency (%) |
| - | 7634 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 38170 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 9163 | |
| - | 7634 | |
| 2 | 6772 | |
| 1 | 6478 | |
| 9 | 1457 | 3.8% |
| 3 | 1446 | 3.8% |
| 6 | 1133 | 3.0% |
| 7 | 1102 | 2.9% |
| 5 | 1100 | 2.9% |
| 8 | 1051 | 2.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 38170 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 9163 | |
| - | 7634 | |
| 2 | 6772 | |
| 1 | 6478 | |
| 9 | 1457 | 3.8% |
| 3 | 1446 | 3.8% |
| 6 | 1133 | 3.0% |
| 7 | 1102 | 2.9% |
| 5 | 1100 | 2.9% |
| 8 | 1051 | 2.8% |
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 3.9 KiB |
| True |
|---|
| Value | Count | Frequency (%) |
| True | 3817 |
smallPeriodDays
Real number (ℝ≥0)
| Distinct | 69 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.12549122 |
|---|---|
| Minimum | 2 |
| Maximum | 94 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 29.9 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 10 |
| Q1 | 18 |
| median | 24 |
| Q3 | 31 |
| 95-th percentile | 45 |
| Maximum | 94 |
| Range | 92 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 10.68405729 |
|---|---|
| Coefficient of variation (CV) | 0.4252277972 |
| Kurtosis | 1.054874715 |
| Mean | 25.12549122 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 0.678057988 |
| Sum | 95904 |
| Variance | 114.1490801 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21 | 222 | 5.8% |
| 22 | 200 | 5.2% |
| 23 | 172 | 4.5% |
| 24 | 166 | 4.3% |
| 25 | 159 | 4.2% |
| 20 | 154 | 4.0% |
| 26 | 151 | 4.0% |
| 19 | 125 | 3.3% |
| 18 | 124 | 3.2% |
| 17 | 121 | 3.2% |
| Other values (59) | 2223 |
| Value | Count | Frequency (%) |
| 2 | 12 | |
| 3 | 15 | |
| 4 | 21 | |
| 5 | 25 | |
| 6 | 21 |
| Value | Count | Frequency (%) |
| 94 | 1 | |
| 75 | 1 | |
| 71 | 1 | |
| 70 | 2 | |
| 69 | 1 |
bigPeriodDays
Real number (ℝ≥0)
| Distinct | 225 |
|---|---|
| Distinct (%) | 5.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.09693477 |
|---|---|
| Minimum | 11 |
| Maximum | 363 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 29.9 KiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 26 |
| median | 45 |
| Q3 | 71 |
| 95-th percentile | 143 |
| Maximum | 363 |
| Range | 352 |
| Interquartile range (IQR) | 45 |
Descriptive statistics
| Standard deviation | 43.12892079 |
|---|---|
| Coefficient of variation (CV) | 0.7688284747 |
| Kurtosis | 5.456888496 |
| Mean | 56.09693477 |
| Median Absolute Deviation (MAD) | 22 |
| Skewness | 1.971304334 |
| Sum | 214122 |
| Variance | 1860.103809 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 22 | 74 | 1.9% |
| 21 | 74 | 1.9% |
| 11 | 69 | 1.8% |
| 13 | 69 | 1.8% |
| 18 | 67 | 1.8% |
| 16 | 64 | 1.7% |
| 14 | 63 | 1.7% |
| 28 | 63 | 1.7% |
| 23 | 62 | 1.6% |
| 17 | 61 | 1.6% |
| Other values (215) | 3151 |
| Value | Count | Frequency (%) |
| 11 | 69 | |
| 12 | 59 | |
| 13 | 69 | |
| 14 | 63 | |
| 15 | 60 |
| Value | Count | Frequency (%) |
| 363 | 1 | |
| 341 | 1 | |
| 332 | 1 | |
| 329 | 1 | |
| 274 | 2 |
riseRange
Real number (ℝ≥0)
| Distinct | 3787 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.066637485 |
|---|---|
| Minimum | 0.5049599416 |
| Maximum | 6.843658966 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 29.9 KiB |
Quantile statistics
| Minimum | 0.5049599416 |
|---|---|
| 5-th percentile | 0.8150045853 |
| Q1 | 0.9131282496 |
| median | 0.9747596154 |
| Q3 | 1.092771353 |
| 95-th percentile | 1.617230818 |
| Maximum | 6.843658966 |
| Range | 6.338699024 |
| Interquartile range (IQR) | 0.1796431033 |
Descriptive statistics
| Standard deviation | 0.3599133146 |
|---|---|
| Coefficient of variation (CV) | 0.3374279638 |
| Kurtosis | 66.23820412 |
| Mean | 1.066637485 |
| Median Absolute Deviation (MAD) | 0.07728857739 |
| Skewness | 6.253659882 |
| Sum | 4071.355279 |
| Variance | 0.129537594 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 14 | 0.4% |
| 0.9333333333 | 3 | 0.1% |
| 1.083333333 | 2 | 0.1% |
| 0.9569892473 | 2 | 0.1% |
| 1.014084507 | 2 | 0.1% |
| 0.9846153846 | 2 | 0.1% |
| 0.984939759 | 2 | 0.1% |
| 0.9512195122 | 2 | 0.1% |
| 1.084337349 | 2 | 0.1% |
| 0.9784946237 | 2 | 0.1% |
| Other values (3777) | 3784 |
| Value | Count | Frequency (%) |
| 0.5049599416 | 1 | |
| 0.5118483412 | 1 | |
| 0.5651372097 | 1 | |
| 0.5766419727 | 1 | |
| 0.5788732394 | 1 |
| Value | Count | Frequency (%) |
| 6.843658966 | 1 | |
| 6.766723014 | 1 | |
| 5.620170801 | 1 | |
| 5.349867976 | 1 | |
| 5.3290135 | 1 |
| Distinct | 3817 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.09832955228 |
|---|---|
| Minimum | -0.09367243928 |
| Maximum | 1.109560968 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 29.9 KiB |
Quantile statistics
| Minimum | -0.09367243928 |
|---|---|
| 5-th percentile | 0.008254124361 |
| Q1 | 0.04507181773 |
| median | 0.07668566002 |
| Q3 | 0.1239437576 |
| 95-th percentile | 0.2545718276 |
| Maximum | 1.109560968 |
| Range | 1.203233407 |
| Interquartile range (IQR) | 0.07887193983 |
Descriptive statistics
| Standard deviation | 0.0936454214 |
|---|---|
| Coefficient of variation (CV) | 0.952362939 |
| Kurtosis | 20.3508024 |
| Mean | 0.09832955228 |
| Median Absolute Deviation (MAD) | 0.03701673905 |
| Skewness | 3.35866059 |
| Sum | 375.323901 |
| Variance | 0.008769464948 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.05131589706 | 1 | < 0.1% |
| 0.211536278 | 1 | < 0.1% |
| 0.05402246277 | 1 | < 0.1% |
| 0.09139827053 | 1 | < 0.1% |
| 0.1174833137 | 1 | < 0.1% |
| 0.009975062344 | 1 | < 0.1% |
| 0.04099378882 | 1 | < 0.1% |
| 0.1092264199 | 1 | < 0.1% |
| 0.05283757339 | 1 | < 0.1% |
| 0.08756412524 | 1 | < 0.1% |
| Other values (3807) | 3807 |
| Value | Count | Frequency (%) |
| -0.09367243928 | 1 | |
| -0.07208780244 | 1 | |
| -0.07103699796 | 1 | |
| -0.06394103337 | 1 | |
| -0.06229068989 | 1 |
| Value | Count | Frequency (%) |
| 1.109560968 | 1 | |
| 1.018942428 | 1 | |
| 0.939125316 | 1 | |
| 0.9299347915 | 1 | |
| 0.9083101793 | 1 |
| Distinct | 3817 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.08041813909 |
|---|---|
| Minimum | 5.072794603 × 105 |
| Maximum | 0.9735135588 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 29.9 KiB |
Quantile statistics
| Minimum | 5.072794603 × 105 |
|---|---|
| 5-th percentile | 0.004240978127 |
| Q1 | 0.02844626816 |
| median | 0.06110714306 |
| Q3 | 0.1090962833 |
| 95-th percentile | 0.2195913781 |
| Maximum | 0.9735135588 |
| Range | 0.9734628309 |
| Interquartile range (IQR) | 0.08065001519 |
Descriptive statistics
| Standard deviation | 0.07826992518 |
|---|---|
| Coefficient of variation (CV) | 0.9732869483 |
| Kurtosis | 14.48346138 |
| Mean | 0.08041813909 |
| Median Absolute Deviation (MAD) | 0.03784713042 |
| Skewness | 2.767151613 |
| Sum | 306.9560369 |
| Variance | 0.006126181188 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.01285153772 | 1 | < 0.1% |
| 0.1133831378 | 1 | < 0.1% |
| 0.07185963973 | 1 | < 0.1% |
| 0.004714375161 | 1 | < 0.1% |
| 0.0889194102 | 1 | < 0.1% |
| 0.04545300593 | 1 | < 0.1% |
| 0.03488869708 | 1 | < 0.1% |
| 0.02974107219 | 1 | < 0.1% |
| 0.1584808589 | 1 | < 0.1% |
| 0.02441304228 | 1 | < 0.1% |
| Other values (3807) | 3807 |
| Value | Count | Frequency (%) |
| 5.072794603 × 105 | 1 | |
| 6.386593263 × 105 | 1 | |
| 7.363770251 × 105 | 1 | |
| 7.365804254 × 105 | 1 | |
| 9.950496281 × 105 | 1 |
| Value | Count | Frequency (%) |
| 0.9735135588 | 1 | |
| 0.802687355 | 1 | |
| 0.7208058746 | 1 | |
| 0.6659070292 | 1 | |
| 0.6578289065 | 1 |
| Distinct | 3817 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.0618161654 |
|---|---|
| Minimum | 7.3067902 × 106 |
| Maximum | 0.7002089755 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 29.9 KiB |
Quantile statistics
| Minimum | 7.3067902 × 106 |
|---|---|
| 5-th percentile | 0.001496452173 |
| Q1 | 0.01451021473 |
| median | 0.04044242964 |
| Q3 | 0.08946215884 |
| 95-th percentile | 0.187324015 |
| Maximum | 0.7002089755 |
| Range | 0.7002016688 |
| Interquartile range (IQR) | 0.07495194412 |
Descriptive statistics
| Standard deviation | 0.06558592217 |
|---|---|
| Coefficient of variation (CV) | 1.060983349 |
| Kurtosis | 8.457706688 |
| Mean | 0.0618161654 |
| Median Absolute Deviation (MAD) | 0.03120548192 |
| Skewness | 2.183813523 |
| Sum | 235.9523033 |
| Variance | 0.004301513186 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0.06493837303 | 1 | < 0.1% |
| 0.00988567847 | 1 | < 0.1% |
| 0.1185733335 | 1 | < 0.1% |
| 0.02323192253 | 1 | < 0.1% |
| 0.05128535955 | 1 | < 0.1% |
| 0.1610916781 | 1 | < 0.1% |
| 0.06982048024 | 1 | < 0.1% |
| 0.1284224527 | 1 | < 0.1% |
| 0.1601224088 | 1 | < 0.1% |
| 0.1166249506 | 1 | < 0.1% |
| Other values (3807) | 3807 |
| Value | Count | Frequency (%) |
| 7.3067902 × 106 | 1 | |
| 4.118090214 × 105 | 1 | |
| 4.335746679 × 105 | 1 | |
| 4.692245567 × 105 | 1 | |
| 5.984732272 × 105 | 1 |
| Value | Count | Frequency (%) |
| 0.7002089755 | 1 | |
| 0.6385946269 | 1 | |
| 0.5470917983 | 1 | |
| 0.4623104353 | 1 | |
| 0.4539257134 | 1 |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| df_index | code | lossRate | startDate | endDate | minDate | isLastSmallPeriod | smallPeriodDays | bigPeriodDays | riseRange | s_bias | m_bias | l_bias | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 1 | -0.129226 | 2011-05-20 | 2011-06-16 | 2011-06-16 | True | 18 | 27 | 0.876509 | 0.015054 | 0.065634 | 0.026031 |
| 1 | 4 | 1 | -0.077278 | 2011-07-29 | 2011-08-10 | 2011-08-08 | True | 9 | 14 | 0.934922 | -0.001698 | 0.007307 | 0.023201 |
| 2 | 12 | 1 | -0.234639 | 2013-03-06 | 2013-04-16 | 2013-04-15 | True | 28 | 59 | 1.064736 | 0.129536 | 0.189792 | 0.151592 |
| 3 | 15 | 1 | -0.187500 | 2013-10-30 | 2013-12-24 | 2013-12-24 | True | 40 | 42 | 0.891089 | 0.146862 | 0.087100 | 0.010167 |
| 4 | 21 | 1 | -0.079597 | 2014-08-04 | 2014-10-09 | 2014-09-22 | True | 43 | 70 | 1.044012 | 0.084487 | 0.032902 | 0.037013 |
| 5 | 28 | 1 | -0.156679 | 2015-01-05 | 2015-02-13 | 2015-02-06 | True | 30 | 69 | 1.278643 | 0.086212 | 0.210216 | 0.084151 |
| 6 | 34 | 1 | -0.203586 | 2015-06-08 | 2015-06-26 | 2015-06-26 | True | 14 | 65 | 1.118075 | 0.081538 | 0.052224 | 0.123846 |
| 7 | 42 | 1 | -0.066116 | 2016-08-15 | 2016-10-10 | 2016-09-26 | True | 34 | 64 | 1.035187 | 0.059197 | 0.036812 | 0.013633 |
| 8 | 45 | 1 | -0.061140 | 2016-12-09 | 2017-01-04 | 2016-12-28 | True | 18 | 28 | 0.952183 | 0.022462 | 0.022185 | 0.008483 |
| 9 | 46 | 1 | -0.050209 | 2017-02-20 | 2017-03-31 | 2017-03-30 | True | 30 | 30 | 0.959205 | 0.026412 | 0.000734 | 0.004940 |
Last rows
| df_index | code | lossRate | startDate | endDate | minDate | isLastSmallPeriod | smallPeriodDays | bigPeriodDays | riseRange | s_bias | m_bias | l_bias | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3807 | 20969 | 603993 | -0.461415 | 2015-06-05 | 2015-07-03 | 2015-07-02 | True | 20 | 151 | 1.486559 | 0.142822 | 0.092978 | 0.176045 |
| 3808 | 20972 | 603993 | -0.344371 | 2015-08-13 | 2015-08-25 | 2015-08-25 | True | 9 | 14 | 0.780645 | 0.061005 | 0.032866 | 0.041628 |
| 3809 | 20973 | 603993 | -0.165254 | 2015-12-21 | 2016-01-05 | 2016-01-05 | True | 11 | 11 | 0.834746 | -0.051066 | 0.104093 | 0.002544 |
| 3810 | 20974 | 603993 | -0.155390 | 2016-07-07 | 2016-08-12 | 2016-08-01 | True | 27 | 27 | 0.867895 | 0.096491 | 0.121941 | 0.003791 |
| 3811 | 20978 | 603993 | -0.234545 | 2017-02-23 | 2017-05-03 | 2017-04-24 | True | 47 | 55 | 1.014613 | 0.254419 | 0.073667 | 0.020045 |
| 3812 | 20987 | 603993 | -0.210773 | 2017-09-11 | 2017-11-02 | 2017-10-18 | True | 34 | 88 | 1.424797 | 0.226835 | 0.077082 | 0.182364 |
| 3813 | 20992 | 603993 | -0.210526 | 2018-03-19 | 2018-04-25 | 2018-04-17 | True | 26 | 39 | 0.914918 | 0.139531 | 0.104949 | 0.046862 |
| 3814 | 20996 | 603993 | -0.231827 | 2019-04-08 | 2019-05-08 | 2019-05-06 | True | 20 | 39 | 0.818557 | 0.056126 | 0.093146 | 0.052772 |
| 3815 | 20999 | 603993 | -0.319188 | 2020-02-14 | 2020-03-17 | 2020-03-16 | True | 23 | 43 | 0.848416 | 0.248848 | 0.085317 | 0.050942 |
| 3816 | 21001 | 603993 | -0.184959 | 2020-08-06 | 2020-09-10 | 2020-09-10 | True | 26 | 28 | 0.856838 | 0.096257 | 0.140618 | 0.012180 |